package jpa.entitys.synchro.staging.logs;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;

import jpa.entitys.synchro.common.CommonEntity;


/**
 * The persistent class for the VW_USER_COLUMNS database table.
 * 
 */
@Entity
@Table(name="VW_USER_COLUMNS")
@NamedQueries({
    @NamedQuery(name = "VwUserColumn.findAll", query = " SELECT c FROM VwUserColumn c order by c.id.tableName, c.id.columnName asc"),
    @NamedQuery(name = "VwUserColumn.findById", query = " SELECT c FROM VwUserColumn c WHERE  c.id = :Id "),
    @NamedQuery(name = "VwUserColumn.findByTable", query = " SELECT c FROM VwUserColumn c WHERE  c.id.tableName = :tableName order by c.id.tableName, c.id.columnName asc")
    }) 
public class VwUserColumn extends CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@EmbeddedId
	private VwUserColumnPk id; 
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}
	
	@Column(name="AVG_COL_LEN")
	private BigDecimal avgColLen;

	@Column(name="CHAR_COL_DECL_LENGTH")
	private BigDecimal charColDeclLength;

	@Column(name="CHAR_LENGTH")
	private BigDecimal charLength;

	@Column(name="CHAR_USED")
	private String charUsed;

	@Column(name="CHARACTER_SET_NAME")
	private String characterSetName;

	@Column(name="COLUMN_ID")
	private BigDecimal columnId;	

	@Column(name="DATA_DEFAULT")
	private String dataDefault;

	@Column(name="DATA_LENGTH")
	private BigDecimal dataLength;

	@Column(name="DATA_PRECISION")
	private BigDecimal dataPrecision;

	@Column(name="DATA_SCALE")
	private BigDecimal dataScale;

	@Column(name="DATA_TYPE")
	private String dataType;

	@Column(name="DATA_TYPE_MOD")
	private String dataTypeMod;

	@Column(name="DATA_TYPE_OWNER")
	private String dataTypeOwner;

	@Column(name="DATA_UPGRADED")
	private String dataUpgraded;

	@Column(name="DEFAULT_LENGTH")
	private BigDecimal defaultLength;

	private BigDecimal density;

	@Column(name="GLOBAL_STATS")
	private String globalStats;

	@Column(name="HIGH_VALUE")
	private byte[] highValue;

	private String histogram;

    @Temporal( TemporalType.DATE)
	@Column(name="LAST_ANALYZED")
	private Date lastAnalyzed;

	@Column(name="LOW_VALUE")
	private byte[] lowValue;

	private String nullable;

	@Column(name="NUM_BUCKETS")
	private BigDecimal numBuckets;

	@Column(name="NUM_DISTINCT")
	private BigDecimal numDistinct;

	@Column(name="NUM_NULLS")
	private BigDecimal numNulls;

	@Column(name="SAMPLE_SIZE")
	private BigDecimal sampleSize;

	@Column(name="TABLE_NAME")
	private String tableName;

	@Column(name="USER_STATS")
	private String userStats;

	@Column(name="V80_FMT_IMAGE")
	private String v80FmtImage;

    public VwUserColumn() {
    }
    
    

	/**
	 * @return the id
	 */
	public VwUserColumnPk getId() {
		return id;
	}



	/**
	 * @param id the id to set
	 */
	public void setId(VwUserColumnPk id) {
		this.id = id;
	}



	public BigDecimal getAvgColLen() {
		return this.avgColLen;
	}

	public void setAvgColLen(BigDecimal avgColLen) {
		this.avgColLen = avgColLen;
	}

	public BigDecimal getCharColDeclLength() {
		return this.charColDeclLength;
	}

	public void setCharColDeclLength(BigDecimal charColDeclLength) {
		this.charColDeclLength = charColDeclLength;
	}

	public BigDecimal getCharLength() {
		return this.charLength;
	}

	public void setCharLength(BigDecimal charLength) {
		this.charLength = charLength;
	}

	public String getCharUsed() {
		return this.charUsed;
	}

	public void setCharUsed(String charUsed) {
		this.charUsed = charUsed;
	}

	public String getCharacterSetName() {
		return this.characterSetName;
	}

	public void setCharacterSetName(String characterSetName) {
		this.characterSetName = characterSetName;
	}

	public BigDecimal getColumnId() {
		return this.columnId;
	}

	public void setColumnId(BigDecimal columnId) {
		this.columnId = columnId;
	}

	public String getDataDefault() {
		return this.dataDefault;
	}

	public void setDataDefault(String dataDefault) {
		this.dataDefault = dataDefault;
	}

	public BigDecimal getDataLength() {
		return this.dataLength;
	}

	public void setDataLength(BigDecimal dataLength) {
		this.dataLength = dataLength;
	}

	public BigDecimal getDataPrecision() {
		return this.dataPrecision;
	}

	public void setDataPrecision(BigDecimal dataPrecision) {
		this.dataPrecision = dataPrecision;
	}

	public BigDecimal getDataScale() {
		return this.dataScale;
	}

	public void setDataScale(BigDecimal dataScale) {
		this.dataScale = dataScale;
	}

	public String getDataType() {
		return this.dataType;
	}

	public void setDataType(String dataType) {
		this.dataType = dataType;
	}

	public String getDataTypeMod() {
		return this.dataTypeMod;
	}

	public void setDataTypeMod(String dataTypeMod) {
		this.dataTypeMod = dataTypeMod;
	}

	public String getDataTypeOwner() {
		return this.dataTypeOwner;
	}

	public void setDataTypeOwner(String dataTypeOwner) {
		this.dataTypeOwner = dataTypeOwner;
	}

	public String getDataUpgraded() {
		return this.dataUpgraded;
	}

	public void setDataUpgraded(String dataUpgraded) {
		this.dataUpgraded = dataUpgraded;
	}

	public BigDecimal getDefaultLength() {
		return this.defaultLength;
	}

	public void setDefaultLength(BigDecimal defaultLength) {
		this.defaultLength = defaultLength;
	}

	public BigDecimal getDensity() {
		return this.density;
	}

	public void setDensity(BigDecimal density) {
		this.density = density;
	}

	public String getGlobalStats() {
		return this.globalStats;
	}

	public void setGlobalStats(String globalStats) {
		this.globalStats = globalStats;
	}

	public byte[] getHighValue() {
		return this.highValue;
	}

	public void setHighValue(byte[] highValue) {
		this.highValue = highValue;
	}

	public String getHistogram() {
		return this.histogram;
	}

	public void setHistogram(String histogram) {
		this.histogram = histogram;
	}

	public Date getLastAnalyzed() {
		return this.lastAnalyzed;
	}

	public void setLastAnalyzed(Date lastAnalyzed) {
		this.lastAnalyzed = lastAnalyzed;
	}

	public byte[] getLowValue() {
		return this.lowValue;
	}

	public void setLowValue(byte[] lowValue) {
		this.lowValue = lowValue;
	}

	public String getNullable() {
		return this.nullable;
	}

	public void setNullable(String nullable) {
		this.nullable = nullable;
	}

	public BigDecimal getNumBuckets() {
		return this.numBuckets;
	}

	public void setNumBuckets(BigDecimal numBuckets) {
		this.numBuckets = numBuckets;
	}

	public BigDecimal getNumDistinct() {
		return this.numDistinct;
	}

	public void setNumDistinct(BigDecimal numDistinct) {
		this.numDistinct = numDistinct;
	}

	public BigDecimal getNumNulls() {
		return this.numNulls;
	}

	public void setNumNulls(BigDecimal numNulls) {
		this.numNulls = numNulls;
	}

	public BigDecimal getSampleSize() {
		return this.sampleSize;
	}

	public void setSampleSize(BigDecimal sampleSize) {
		this.sampleSize = sampleSize;
	}

	public String getTableName() {
		return this.tableName;
	}

	public void setTableName(String tableName) {
		this.tableName = tableName;
	}

	public String getUserStats() {
		return this.userStats;
	}

	public void setUserStats(String userStats) {
		this.userStats = userStats;
	}

	public String getV80FmtImage() {
		return this.v80FmtImage;
	}

	public void setV80FmtImage(String v80FmtImage) {
		this.v80FmtImage = v80FmtImage;
	}

}